package wetogether.travelinfo.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import wetogether.travelinfo.vo.TravelCommentVO;
import wetogether.travelinfo.vo.TravelFrVO;
import wetogether.travelinfo.vo.TravelImageVO;
import wetogether.travelinfo.vo.TravelInfoVO;
import wetogether.travelinfo.vo.TravelVacancyVO;
import wetogether.travelinfo.vo.TravelZoneVO;

public interface OutputTravelInfoDAO {
	// 랭킹
	public List<Map> getTravelPlaceRanking(int locationid) throws SQLException;
	// 값 가져오기
	public Integer getPlaceCommentSeq() throws SQLException;
	public TravelZoneVO getTravelZone(int locationid) throws SQLException;
	public TravelInfoVO getTravelInfo(String place) throws SQLException;
	public List<String> getPlaceImageList(String place) throws SQLException;
	public List<TravelImageVO> getTotalPlaceImageList(String place) throws SQLException;
	public List<TravelVacancyVO> getPlaceVacancyList(String place) throws SQLException;
	public List<TravelFrVO> getPlaceFrList(String place) throws SQLException;
	public List<TravelCommentVO> getPlaceCommentList(String place) throws SQLException;
	public ArrayList<TravelCommentVO> getTravelCommentList(Map map) throws SQLException;
	public Integer getPlaceCommentCount(String place) throws SQLException;
	public TravelCommentVO getPlaceComment(TravelCommentVO commentVO) throws SQLException;
	// 값이 있는지 확인
	public List<TravelZoneVO> findTravelZoneList() throws SQLException;
	public List<String> findTravelPlaceList(int locationid) throws SQLException;
	public String isPlaceNotice(String place) throws SQLException;
	public List<String> isPlaceVacancy(String place) throws SQLException;
	public List<String> isPlaceFr(String place) throws SQLException;
}
